<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/temp.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>temp</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="636" border="0">
  <tr>
  <td width="221"><a href="index.php">HOME PAGE </a></td>
    <td width="77"><a href="index.php">User Login</a> </td>
	<td width="114"><a href="superUserLogin.php">Super User Login</a> </td>
    <td width="93"><a href="managerLogin.php">Manager Login</a> </td>
    <td width="109"><a href="adminLogin.php">Adminster Login</a> </td>
  </tr>
</table>
<!-- InstanceBeginEditable name="EditRegion" -->
<?php 
    include ("../Connections/cpsms.php");
 	$query = "select * from users;";
	$sql = mysql_query($query) or die(mysql_error());
	$array = mysql_fetch_array($sql);

?>
<table width="862" border="1">
  <tr>
    <td width="740" colspan="4"><table width="489" height="36" border="1">
      <tr>
        <td >Police ID</td>
        <td >Archive name</td>
        <td >Gender</td>
        <td >DOB</td>
        <td >Rank</td>
        <td >Birth place</td>
        <td >Ethic</td>
        <td>Political Back</td>
        <td>Current  Position</td>
        <td >Archive No.</td>
        <td >Police WorkDate</td>
        <td >details</td>
        <td >Edit</td>
        <td >delete</td>
      </tr>
      <?PHP
   while($array){
      $archiveid = $array['Archiveid'];
      $birthplace = $array['Birthplace'];
      $CurrentPosition = $array['CurrentPosition'];
      $DOB = $array['DOB'];
      $Ethic = $array['Ethic'];
	  $FirstEducation = $array['FirstEducation'];
      $HighestAcademicInstitution = $array['HighestAcademicInstitution'];
      $HighestEducation = $array['HighestEducation'];
      $loginname = $array['loginname'];
      $PartyDate = $array['PartyDate'];
	  $loginpassword = $array['loginpassword'];
      $photo = $array['photo'];
      $PoliceIDNo = $array['PoliceIDNo'];
      $PoliceWorkDate = $array['PoliceWorkDate'];
      $Political = $array['Political'];
      $Rank = $array['Rank'];
	  $username = $array['username'];
	  $WorkDate = $array['WorkDate'];
	  
	  if($array['Gender'] == 1)
	  {$Gender = "Mail";}
	  else if($array['Gender'] == 0)
	  {$Gender = "Femail";}
	  else 
	  {$Gender = "";}

      echo ("<tr><td>" .$PoliceIDNo ."</td><td>" .$username ."</td><td>" .$Gender ."</td><td>" .$DOB ."</td><td>" .$Rank ."</td><td>" .$birthplace.'$' ."</td><td>" .$Ethic ."</td><td>" .$Political ."</td><td>" .$CurrentPosition ."</td><td>" ."PC".$archiveid ."</td><td>" .$WorkDate ."</td><td ><a href='UCUserDelete.php?id=".$archiveid ."'>details</a></td><td ><a href='edituser.php?id=".$archiveid ."'>Edit</a></td><td ><a href='superUserView.php?id=".$archiveid ."'>Delete</a></td></tr>");
      $array = mysql_fetch_array($sql);
   }
?>
    </table></td>
  </tr>
  <tr>
    <td width="369"><form id="form1" name="form1" method="post" action="addManager.php">
      <input type="submit" name="Submit" value="Add" />
    </form></td>
    <td width="369">&nbsp;</td>
    <td width="740">&nbsp;</td>
    <td width="740"><form id="form4" name="form4" method="post" action="">
      <input type="submit" name="Submit4" value="Exit" />
    </form></td>
  </tr>
</table>
<form id="form5" name="form5" method="post" action="">
  <input type="submit" name="Submit5" value="Retrival" />
</form>
<p>&nbsp;</p>
<p>&nbsp;</p>
<!-- InstanceEndEditable -->
footer
</body>
<!-- InstanceEnd --></html>
